package com.company.project.mapper.ldjsc.szjt;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.company.project.entity.ldjsc.szjt.JscSzjtCzbzxajgcjsEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *
 *
 * @author wenbin
 * @email *****@mail.com
 * @date 2025-08-19 16:41:34
 */
@Mapper
public interface JscSzjtCzbzxajgcjsMapper extends BaseMapper<JscSzjtCzbzxajgcjsEntity> {

    @Select("select id,data_index,refine_name,ascription,num1,num2,num3,num4,num5,num6,num7,num8,num9,num10,num11,time_type,time_value,year,source,admin_dis,update_time " +
            "from jsc_szjt_czbzxajgcjs where  replace(ascription,' ','') = #{ascription} ORDER BY year desc,time_value desc,id desc ;")
    List<JscSzjtCzbzxajgcjsEntity> selectAscription(String ascription);
}
